Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

ryc_relationship_field table — rycrf

This table defines the fields used to join the two tables defined in the ryc_relationship table that this table is a child of. Multiple field joins are supported, as well as role named foreign keys where the field names in the two tables do not match.

Table 4–29 lists the table’s FLA, fields, and foreign keys.

Table 4–29: ryc_relationship_field table information 

Table FLA	Fields (data type)	Foreign keys
rycrf	relationship_field_obj (Decimal) relationship_obj (Decimal) join_sequence (Integer) parent_table_name (Character) parent_field_name (Character) use_parent_constant_value (Logical) parent_constant_value (Character) child_table_name (Character) child_field_name (Character) use_child_constant_value (Logical) child_constant_value (Character)	relationship_obj

Table 4–30 gives details of the table’s indexes.

Table 4–30: ryc_relationship_field index information 

Index name	Elements	Type
XPKryc_relationship_field	relationship_field_obj	Primary Unique
XAK1ryc_relationship_field	relationship_obj join_sequence	Unique
XIE1ryc_relationship_field	parent_table_name	Nonunique
XIE2ryc_relationship_field	parent_field_name	Nonunique
XIE3ryc_relationship_field	child_table_name	Nonunique
XIE4ryc_relationship_field	child_field_name	Nonunique

The join sequence determines the order to reference the fields when constructing a dynamic where clause to join the tables. When joining to some tables, additional constant values for fields in the child table or parent table might need to be specified. This functionality is supported.

For example, consider a join from the Repository’s gsc_object_type table to the ryc_attribute_value table. There is a single field from the parent table, the object_type_obj. But you must additionally specify a 0 value for other fields such as container_smartobject_obj, smartobject_obj, and object_instance_obj. This means that when using constant values, the child or the parent field can be left blank.